﻿if exists (select * from dbo.sysobjects where name = 'sp_tblNews_Update')
	drop procedure [dbo].[sp_tblNews_Update]
Go 
CREATE PROCEDURE dbo.sp_tblNews_Update
@_nid	int,
@_ntitle	nvarchar(256),
@_ncontent	nvarchar(4000),
@_ncreatedate	datetime
AS
UPDATE tblNews SET [_ntitle] = @_ntitle,[_ncontent] = @_ncontent,[_ncreatedate] = @_ncreatedate
WHERE  _nid= @_nid
Go